Vacancy expired!
Job DescriptionOracle Energy and Water delivers proven software applications that help utility companies of all types and sizes achieve competitive advantage, business performance excellence and a lower total cost of technology ownership. Oracle Energy and Water integrates industry-specific customer care and billing, network management, work and asset management, mobile workforce management and meter data management applications with the capabilities of Oracle's industry-leading enterprise applications, business intelligence tools, middleware, database technologies, as well as servers and storage. The software enables customers to adapt more nimbly to market deregulation, meet ever-evolving customer demands and deliver on environmental conservation commitments.Oracle Energy and Water Global Business Unit enhances the Oracle brand by delivering best of breed business solutions and professional services to the utility industry around the world. Our customers value us above all other competitors because of our thought leadership, understanding of their needs, talents and superior ability to provide world-class solutions for the challenges they face.Data Conversion Specialist Role:The Oracle Data Conversion Specialist engages with clients to move their data from a legacy application to one of Oracle’s Energy and Water applications.The Oracle Data Conversion Specialist conducts discovery workshops to identify data elements in the legacy system, to map those elements into their Oracle equivalents, and to develop a conversion strategy. With the data elements and strategy defined, the Data Conversion Specialist uses/develops tools to create the scripts to extract data to a staging database, then transforms and loads the data to the target application. Also, coordinates mock conversion and dress rehearsal activities and resolves data issues. Once the data is loaded, the Data Conversion Specialist validates data against the legacy system to ensure the conversion was successful, and complete. This is done for large volumes of data.Essential Job Functions:
Lead workshops and design sessions to capture and document conversion requirements
Develop data conversion plans, strategy, and approach
Be an onsite technical lead, as necessary, and coordinate with offshore team to accomplish activities
Be a technical liaison with Client, Project Management and Oracle product group
Work on Oracle Energy and Water data conversion and integration projects
Design and implement data conversion of CIS solutions to Oracle Energy and Water applications
Design programs and scripts for the creation and migration of data from source to target systems
Participate in the development and unit testing of data extract scripts
Participate in the development and unit testing of data conversion scripts
Design and develop Extract, Transform, and Load (ETL) jobs
Liaise with business and participate with design walkthroughs; discuss/explain functional requirements
Identify and coordinate legacy data cleanup activities with the business
Identify potential risk and problem areas and develop procedures that provide effective workarounds to the problem at hand
Create balancing and audit control procedures and reports
Advise business on options, risks and any impacts related to data conversion & migration
Manage all data conversion activities from project initiation to production cutover and support
Share knowledge and create proper documentation related to the ETL, data mapping and migration efforts
ResponsibilitiesThe ideal candidate will be a skilled technical consultant with experience on multiple Oracle Energy and Water projects, along with demonstrable leadership experience.Essential Skills:
Have experience in large-scale IT implementations, preferably gained within a utility and/or major consulting organization as a DBA, WebLogic Administrator, or technical architect
Strong Oracle Database Administration skills and experience working with Oracle Database 19C+.
Possess excellent analytical, communication (verbal and written) and presentation skills.
Knowledge of Oracle Energy and Water applications: CCB, C2M, CCS, MDM, WACS, WAM and/or MSCS.
Experience in data conversion from legacy source CIS systems to Oracle Energy and Water applications that are based on the Oracle Utilities Application Framework
Proficient in either PL/SQL, ODI, or SQL Loader to develop code required for data profiling, data extract, and data transformation activities
Understand the legacy data models, target data models, and identify the data quality issues
Ability to verify the integrity of the transformed data
Ability to resolve data conversion errors
Additional Skills:
Strong Unix skills and experience with UNIX operating systems like RH Linux, Oracle Linux etc.
Able to tune ETL jobs to achieve optimum performance
Ability to travel up to 45% for client assignments to any destination
Fluent communication (written and spoken) in English
Accomplished technical writer
Disclaimer:Certain US customer or client-facing roles may be required to comply with applicable requirements, such as immunization and occupational health mandates.Range and benefit information provided in this posting are specific to the United States onlyHiring Range: from $64,100 to $158,200 per annum. May be eligible for bonus and equity.Oracle maintains broad salary ranges for its roles in order to account for variations in knowledge, skills, experience, market conditions and locations, as well as reflect Oracle’s differing products, industries and lines of business.Candidates are typically placed into the range based on the preceding factors as well as internal peer equity.Oracle offers a comprehensive benefits package which includes the following:
Medical, dental, and vision insurance, including expert medical opinion
Short term disability and long term disability
Life insurance and AD&D
Supplemental life insurance (Employee/Spouse/Child)
Health care and dependent care Flexible Spending Accounts
Pre-tax commuter and parking benefits
401(k) Savings and Investment Plan with company match
Paid time off: Flexible Vacation is provided to all eligible employees assigned to a salaried (non-overtime eligible) position. Accrued Vacation is provided to all other employees eligible for vacation benefits. For employees working at least 35 hours per week, the vacation accrual rate is 13 days annually for the first three years of employment and 18 days annually for subsequent years of employment. Vacation accrual is prorated for employees working between 20 and 34 hours per week. Employees working fewer than 20 hours per week are not eligible for vacation.
11 paid holidays
Paid sick leave: 72 hours of paid sick leave upon date of hire. Refreshes each calendar year. Unused balance will carry over each year up to a maximum cap of 112 hours.
Paid parental leave
Adoption assistance
Employee Stock Purchase Plan
Financial planning and group legal
Voluntary benefits including auto, homeowner and pet insurance
About UsAn Oracle career can span industries, roles, Countries and cultures, giving you the opportunity to flourish in new roles and innovate, while blending work life in. Oracle has thrived through 40+ years of change by innovating and operating with integrity while delivering for the top companies in almost every industry.In order to nurture the talent that makes this happen, we are committed to an inclusive culture that celebrates and values diverse insights and perspectives, a workforce that inspires thought leadership and innovation.Oracle offers a highly competitive suite of Employee Benefits designed on the principles of parity, consistency, and affordability. The overall package includes certain core elements such as Medical, Life Insurance, access to Retirement Planning, and much more. We also encourage our employees to engage in the culture of giving back to the communities where we live and do business.At Oracle, we believe that innovation starts with diversity and inclusion and to create the future we need talent from various backgrounds, perspectives, and abilities. We ensure that individuals with disabilities are provided reasonable accommodation to successfully participate in the job application, interview process, and in potential roles. to perform crucial job functions.That’s why we’re committed to creating a workforce where all individuals can do their best work. It’s when everyone’s voice is heard and valued that we’re inspired to go beyond what’s been done before.Oracle is an Equal Employment Opportunity Employer . All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law. Which includes being a United States Affirmative Action Employer
